<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Duediligencebarbados</title>

<%@ page language = "java"	import="java.io.*,java.sql.*" %>

<%@include file="../dbcon.jsp"%>
<%
// Not Login or User Not Admin
	/*if ( session.getAttribute("SES_USERSNO") == null || (Integer)session.getAttribute("SES_USERTYPE") != 1  )
	{
		response.sendRedirect("index.jsp");
		return;
	}*/
	
	int iSno = 0;
	int iRecType = 1;
	int iUserType = 1;
	String sTmp = "";
	
String sOwnerName = "",sTitle = "",sMake = "", sLocation = "", sCountryplanningapprovalno = "",sLandtaxno = "", sBWAAccountno="";
	String sPrice = "", sDesc = "" ,sEmail = "",sMobile = "", sLandline = "",sAddress = "";
	
	sTmp = request.getParameter("ID");
	if ( sTmp != null && !sTmp.equals("") )
		iSno = Integer.parseInt(sTmp);
	sTmp = request.getParameter("RecType");
	if ( sTmp != null && !sTmp.equals("") )
		iRecType = Integer.parseInt(sTmp);		
	if ( iSno > 0 ) // Edit
	{
		iRecType = 2;
		Statement Stmt = null;
	    ResultSet Rs = null;
		try
		{
			String sQry = "select * from tbl_vechile where reg_flag != 3 and status=1 ";
			sQry += "and id="+ iSno;
		System.out.println(sQry);
			Stmt = Con.createStatement();
			Rs = Stmt.executeQuery(sQry);
			if ( Rs.next() )
			{
				sTitle = request.getParameter("txt_title");
				sOwnerName = request.getParameter("txt_ownername");	
				sCountryplanningapprovalno = request.getParameter("txt_approvalno");	
				sLandtaxno = request.getParameter("txt_taxno");
				sBWAAccountno = request.getParameter("txt_accountno");
				sDesc = request.getParameter("txt_desc");
				sEmail = request.getParameter("txt_email");
				sMobile = request.getParameter("txt_mobile");
				sLandline = request.getParameter("txt_landline");
				sAddress = request.getParameter("txt_address");	
			}
		}catch(Exception e){ System.out.println(e); }
		
		if (Rs != null ) Rs.close();
		if (Stmt != null ) Stmt.close();
		if (Con != null ) Con.close();
	}
%>

	<link href="../css/default.css" rel="stylesheet" type="text/css" />
	<link href="../css/main.css" rel="stylesheet" type="text/css" />			
<!-- Menu -->	
	<link type="text/css" href="../menu/menu.css" rel="stylesheet" />
    <script type="text/javascript" src="../menu/menu.js"></script>
	
<script type="text/JavaScript">
	var vLoginStatus = <%=(String)session.getAttribute("SES_USERSNO")%>;
	var vUserType = <%=iUserType%>;	
/* Form Validation */
	jQuery(document).ready(function(){
		// binds form submission and fields to the validation engine
		//jQuery("#frmUser").validationEngine();
	});
	
</script>
</head>	
	
<body >
<table width="100%" cellpadding="0" cellspacing="0" border="0" >
<tr><td align="center">
<table width="1004px" cellpadding="0" cellspacing="0" border="0" class="formbk" >
<tr> <td align="center" >
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="wrapper" >
<tr><td align="center"><script src="../js/top.js"></script></td></tr>
<tr><td colspan="2" >&nbsp;</td></tr>
<tr>
  <td colspan="2" align="center" class="mainhead" >Real Estate - Property </td>
</tr>
<tr><td colspan="2" >&nbsp;</td></tr>
  <tr valign="top" >
  <td> 
	<table width='100%' cellpadding="0" cellspacing="0" border="0" >
	<tr>
		<td align="center" width='50%' valign="top">
			<table width='60%' cellpadding="0" cellspacing="0" border="0" id="table-2">
				<thead>
					<tr><th align="center" valign="middle" colspan="3">Basic&nbsp; Details</th></tr>
				</thead>
				<tbody>
					<tr>
						<td width="35%" align="left">Title</td>
						<td width="1%">:</td>
						<td align="left" class="style1">
							<input type="text" size="25" style="width: 274px" id="txt_title" />	
						</td>
					</tr>
					<tr>
						<td align="left">Owner Name</td>
						<td >:</td>
						<td align="left" class="style1">
							<input type="text" size="25"  id="txt_ownername"/>
						</td>
					</tr>
					
					<tr>
						<td align="left">Country Planning Approval No.	</td>
						<td>:</td>
						<td align="left" class="style1">
							<input type="text" size="15" id="txt_approvalno" />
						</td>
					</tr>
					<tr>
						<td align="left">Land Tax No.</td>
						<td>:</td>
						<td align="left" class="style1">
							<input type="text" size="15"  id="txt_taxno"/>
						</td>
					</tr>
					<tr>
						<td align="left">BWA Account No.</td>
						<td>:</td>
						<td align="left" class="style1">
							<input type="text" size="15" id="txt_accountno"/>
						</td>
					</tr>
					<tr><th align="center" valign="middle" colspan="3">	Contact Details	</th></tr>
					<tr>
						<td align="left">Email ID</td>
						<td>:</td>
						<td align="left" class="style1">
							<input type="text" size="25" id="txt_email"/>
						</td>
					</tr>
					<tr>
						<td align="left">Mobile Number </td>
						<td>:</td>
						<td align="left" class="style1">
							<input type="text" size="25" id="txt_mobile"/>
						</td>
					</tr>
					<tr>
						<td align="left">Landline Number</td>
						<td>:</td>
						<td align="left" class="style1">
							<input type="text" size="25"  id="txt_landline"/>
						</td>
					</tr>
					<tr>
						<td align="left">Address </td>
						<td>:</td>
						<td align="left" class="style1">
							<textarea type="text" size="15" id="txt_address"></textarea>
						</td>
					</tr>
					<tr>
						<th align="center" valign="middle" colspan="3">Other Details</th>
					</tr>
					<tr>
						<td align="left">Description</td>
						<td>:</td>
						<td align="left" class="style1">
							<textarea type="text" rows="5" cols="30" id="ta_desc" name="ta_desc" ><%=sDesc%></textarea>
						</td>
					</tr>
					<tr><td colspan="3" align="center">&nbsp;</td></tr>
				</tbody>
			</table>
		</td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td colspan="2" align="center">
			<a href="#" onclick="validation();" ><img src="../images/bt_save.png" border="0" ></a>
		</td>
	</tr>
	<tr><td colspan="2">&nbsp;</td>
</table>
</td></tr>
<tr><td align="center"><script src="../js/bottom.js"></script></td></tr>
</table>
</td></tr></table>
</td></tr></table>
</body>
</html>
